<!--

    Copyright (c) 2005, 2018 Oracle and/or its affiliates. All rights reserved.
    Portions Copyright &#169; [2017-2020] Payara Foundation and/or affiliates.

    This program and the accompanying materials are made available under the
    terms of the Eclipse Public License v. 2.0, which is available at
    http://www.eclipse.org/legal/epl-2.0.

    This Source Code may also be made available under the following Secondary
    Licenses when the conditions for such availability set forth in the
    Eclipse Public License v. 2.0 are satisfied: GNU General Public License,
    version 2 with the GNU Classpath Exception, which is available at
    https://www.gnu.org/software/classpath/license.html.

    SPDX-License-Identifier: EPL-2.0 OR GPL-2.0 WITH Classpath-exception-2.0

-->

<p><a id="task-jdbcresourcesedit" name="task-jdbcresourcesedit"></a><a id="GHJDB00033" name="GHJDB00033"></a></p>

<h4><a id="sthref9" name="sthref9"></a>To Edit a JDBC Resource</h4>
<a name="BEGIN" id="BEGIN"></a>
<ol>
<li>
<p>In the navigation tree, expand the Resources node.</p>
</li>
<li>
<p>Under the Resources node, expand the JDBC node.</p>
</li>
<li>
<p>Under the JDBC node, select the JDBC Resources node.</p>
<p>The JDBC Resources page opens.</p>
</li>
<li>
<p>On the JDBC Resources page, click the name of the resource to be edited.</p>
<p>The Edit JDBC Resource page opens.</p>
</li>
<li>
<p>From the Pool Name drop-down list, select a connection pool to be associated with this JDBC resource.</p>
</li>
<li>
<p>In the Deployment Order field, type a number to specify the deployment order of the JDBC resource.</p>
<p>Resources with a lower number are loaded first at server startup. The default value is 100.</p>
</li>
<li>
<p>In the Description field, type a short description for this JDBC resource.</p>
</li>
<li>
<p>In the Additional Properties section, specify additional properties.</p>
<p>Payara Server does not define any additional properties for JDBC resources.</p>
<ul>
<li>
<p>To add a property, click the Add Property button. In the blank row that appears, type the property name in the Name field, and type the property value in the Value field.</p>
</li>
<li>
<p>To modify a property, edit that property's Value field.</p>
</li>
<li>
<p>To delete a property, select the checkbox to the left of the Name field of the property that you are deleting, then click the Delete Properties button.</p>
</li>
</ul>
</li>
<li>
<p>Click the Target tab to manage Resource Targets.</p>
<ol type="a">
<li>
<p>Enable or disable defined targets for the resource, as desired.</p>
</li>
<li>
<p>Click the Manage Targets button to add or remove targets for the resource.</p>
</li>
</ol>
<p>See <a href="task-jdbcresourcetargets.html">To Edit JDBC Resource Targets</a> for more information.</p>
</li>
<li>
<p>Click the General tab to return to the Edit JDBC Resource page.</p>
</li>
<li>
<p>Click Save.</p>
</li>
</ol>
<a id="sthref10" name="sthref10"></a>
<h5>See Also</h5>
<ul>
<li>
<p><a href="task-setdbaccess.html">To Set Up Database Access</a></p>
</li>
<li>
<p><a href="task-integratejdbcdriver.html">To Integrate a JDBC Driver</a></p>
</li>
<li>
<p><a href="task-jdbcresourcenew.html">To Create a JDBC Resource</a></p>
</li>
<li>
<p><a href="task-jdbcresourcetargets.html">To Edit JDBC Resource Targets</a></p>
</li>
<li>
<p><a href="task-jdbcresourcesdelete.html">To Delete a JDBC Resource</a></p>
</li>
<li>
<p><a href="task-jdbcconnectionpoolnew.html">To Create a JDBC Connection Pool</a></p>
</li>
<li>
<p><a href="task-jdbcconnectionpooledit.html">To Edit JDBC Connection Pool General Settings</a></p>
</li>
<li>
<p><a href="task-jdbcconnectionpooladvance.html">To Edit JDBC Connection Pool Advanced Attributes</a></p>
</li>
<li>
<p><a href="task-verifyconnpoolsettings.html">To Verify Connection Pool Settings</a></p>
</li>
<li>
<p><a href="task-jdbcconnectionpoolproperty.html">To Edit JDBC Connection Pool Properties</a></p>
</li>
<li>
<p><a href="task-jdbcconnectionpooldelete.html">To Delete a JDBC Connection Pool</a></p>
</li>
</ul>


<small>Copyright &#169; 2005, 2017, Oracle and/or its affiliates. All rights reserved. <a href="docinfo.html">Legal Notices</a></small>
<small>Portions Copyright &#169; [2017-2020] Payara Foundation and/or affiliates.</small>
